home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 65.zip
/
BS1 part 65
/
Maxiplan IV 4.09 d1.adf
/
MaxiPlan
/
PlanHelp
/
data.help
< prev
next >
Wrap
Text File
|
1992-01-25
|
5KB
|
116 lines
---------------------------------------------------------------------
DATA MENU HELP
---------------------------------------------------------------------
Data Menu Items are used to build Databases and perform database
operations. Before you can execute a database operation, you must
first name a Database Range and then name a Criteria Range.
---------------------------------------------------------------------
Find
---------------------------------------------------------------------
Highlights Records that match a certain criteria. Find starts at the
top of the Database and locates the first match. To see the next
match, use the down Arrow Key. The up Arrow Key is used to see a
previous matching Record. Esc key will leave Find Mode.
---------------------------------------------------------------------
Extract
---------------------------------------------------------------------
Copies selected Records onto a new Range on the Worksheet.
All - all Records are copied including
duplicates.
Unique - Duplicate Records are dropped
after one Record is copied.
---------------------------------------------------------------------
Delete
---------------------------------------------------------------------
Delete removes selected Records from the Worksheet. Once a Record
is removed, all Records below it are moved up one Row and a blank
record is inserted at the bottom. A Requester verifies each
deletion.
Single Record - deletes the currently selected record.
Matching Records - deletes all records matching the criteria.
---------------------------------------------------------------------
Sort
---------------------------------------------------------------------
Reorders Records of Database based on a defined Criteria. The
Criteria typically takes the form of Field Names in the first
Row of the Criteria Range. The second Row has numbers that tell
MaxiPlan what order to sort the Fields. For example, to sort a
phone list by last name, then first name, put a 2 in the last name
Field and a 1 in the first name Field.
---------------------------------------------------------------------
Define Database
---------------------------------------------------------------------
Used to treat a selected Range as a Database. First Row of the
Range must contain Field Names. A Requester appears to key in
the Database Name.
---------------------------------------------------------------------
Define Criteria
---------------------------------------------------------------------
Used to treat a selected Range as a Database Criteria. Various
types of Criteria have different formats. Generally, If more than
one Field is filled in within a given row, then ALL CONDITIONS
within that Row of the Criteria Range must be met (AND function).
If more than one Row is filled in, then any of the Rows causing a
match will select a Record ( OR function).
To match a specific criteria YOU MUST PUT AN EQUAL SIGN in front
of the criteria comparison field. Examples: =>32 or =<>55.
To test for an exact match you must use two equal signs: ==37.
A Requester appears to key in a Criteria Name.
---------------------------------------------------------------------
Select Database
---------------------------------------------------------------------
Used to access an existing Database. Displays a Database Name
Requester window for selecting an existing Database.
---------------------------------------------------------------------
Select Crtiera
---------------------------------------------------------------------
Used to access an existing Criteria Range. Displays a Criteria Name
Requester window for selecting an existing Criteria Range.
---------------------------------------------------------------------
Data View Mode
---------------------------------------------------------------------
Puts MaxiPlan in the DataView Mode with it's own DataView Menu. All
other menus except Project have been removed. DataView allows you to
work the Database Worksheets in a database style.
---------------------------------------------------------------------
Save Data as Text
---------------------------------------------------------------------
Allows any Database Range to be renamed and saved as a text file for
export to other programs such as for mail merge. Cells will be
delineated by a tab.
---------------------------------------------------------------------
Load Text as Data
---------------------------------------------------------------------
Allows the import of files saved in a tab delineated format into a
MaxiPlan Database.